package com.example.demo.dao;

import com.example.demo.pojo.Repertorygoods;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface RepertorygoodsDao {
    int insert(Repertorygoods record);

    int insertSelective(Repertorygoods record);

    @Select("select *  from repertorygoods where repertoryId=#{repertoryId}")
    List<Repertorygoods> selectBy(@Param("repertoryId") Integer repertoryId);

    int update(Repertorygoods record);
    @Select("SELECT repertorygoods.goodsId FROM repertorygoods WHERE repertorygoods.repertoryId=#{repertoryId}")
    List<Repertorygoods> selectGoods(int repertoryId);

}